Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# Summary of Analytic Workspace Maintenance Views

The analytic workspace maintenance views are summarized in the following table.

Table 4-1 Analytic Workspace Maintenance Views

Public Synonym | Description
--- | ---
ALL_AW_CUBE_AGG_LEVELS | Describes the levels in aggregation specifications for cubes.
ALL_AW_CUBE_AGG_MEASURES | Describes the measures in aggregation specifications for cubes.
ALL_AW_CUBE_AGG_PLANS | Describes the aggregation specifications for cubes.
ALL_AW_CUBE_ENABLED_HIERCOMBO | Describes the hierarchy combinations associated with cubes.
ALL_AW_CUBE_ENABLED_VIEWS | Describes the fact views that can be generated for workspace cubes.
ALL_AW_DIM_ENABLED_VIEWS | Describes the dimension views that can be generated for workspace dimensions.
ALL_AW_LOAD_CUBES | Describes the load specifications for cubes.
ALL_AW_LOAD_CUBE_DIMS | Describes the composite specifications for cubes.
ALL_AW_LOAD_CUBE_FILTERS | Describes the filter conditions associated with load specifications for cubes.
ALL_AW_LOAD_CUBE_MEASURES | Describes the measures in cube load specifications.
ALL_AW_LOAD_CUBE_PARMS | Describes parameters of cube load specifications.
ALL_AW_LOAD_DIMENSIONS | Describes the load specifications for dimensions.
ALL_AW_LOAD_DIM_FILTERS | Describes the filter conditions associated with load specifications for dimensions.
ALL_AW_LOAD_DIM_PARMS | Describes parameters of dimension load specifications.
ALL_AW_OBJ | Lists the objects in all analytic workspaces available to the current user. The workspaces may have been created by `DBMS_AWM` or by another tool, such as the OLAP Analytic Workspace API.
ALL_AW_PROP | Lists the OLAP DML properties and their values in all analytic workspaces available to the current user. The workspaces may have been created by `DBMS_AWM` or by another tool, such as the OLAP Analytic Workspace API.